Tabela LServTimePatternVisitType

Definicja tabeli LServTimePatternVisitType

Name

LServTimePatternVisitType

Code

LServTimePatternVisitType

Comment

PL: Tabela przechowuje zmiany domyslnych czasów wykonan dla typu rezerwacji w kontekscie danego wzorca dla danej uslugi
EN: Table contains default service execution time changes for certain pattern.


Lista kolumn tabeli LServTimePatternVisitType

Name

Code

LServTimePatternVisitTypeID

LServTimePatternVisitTypeID

ServID

ServID

TimePatternID

TimePatternID

VisitTypeID

VisitTypeID

Duration

Duration

Active

Active


Kolumna LServTimePatternVisitTypeID tabeli LServTimePatternVisitType

Definicja kolumny LServTimePatternVisitTypeID tabeli LServTimePatternVisitType

Name

LServTimePatternVisitTypeID

Code

LServTimePatternVisitTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli LServTimePatternVisitType

Definicja kolumny ServID tabeli LServTimePatternVisitType

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimePatternID tabeli LServTimePatternVisitType

Definicja kolumny TimePatternID tabeli LServTimePatternVisitType

Name

TimePatternID

Code

TimePatternID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VisitTypeID tabeli LServTimePatternVisitType

Definicja kolumny VisitTypeID tabeli LServTimePatternVisitType

Name

VisitTypeID

Code

VisitTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Duration tabeli LServTimePatternVisitType

Definicja kolumny Duration tabeli LServTimePatternVisitType

Name

Duration

Code

Duration

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli LServTimePatternVisitType

Definicja kolumny Active tabeli LServTimePatternVisitType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli LServTimePatternVisitType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServTimePatternVisitType

Definicja klucza Identifier_1 tabeli LServTimePatternVisitType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment